tg-me.com/sql_for_qa/113
Last Update:
Даны следующие таблицы:
Customers
| CustomerID | Name | City |Orders
|------------|----------|---------------|
| 1 | John | New York |
| 2 | Jane | Chicago |
| 3 | Mark | Los Angeles |
| 4 | Sarah | San Francisco |
| 5 | Michael | Houston |
| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 1 | 2022-05-15 | 500 |
| 2 | 2 | 2022-06-20 | 750 |
| 3 | 3 | 2022-06-25 | 1000 |
| 4 | 1 | 2022-07-10 | 300 |
| 5 | 4 | 2022-08-05 | 900 |
Какой из следующих SQL запросов вернет имена покупателей, разместивших как минимум 2 заказа?A)
SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) >= 2)
B) SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerID HAVING COUNT(*) >= 2
C) SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE COUNT(*) >= 2
D) SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders WHERE COUNT(*) >= 2)
BY SQL для тестировщика
Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283
Share with your friend now:
tg-me.com/sql_for_qa/113